EMT Practice Test

1. Question Content...

---

Question1: Universal Containers asks a CRM Analytics consultant to review the performance of its local data sync.
After removing unused objects and fields from connected data, what else should the consultant do to improve performance of the data sync?

Question2: CRM Analytics team plans to enable data sync.
Which limit specific to data syne should the team consider before enabling the feature because it may impact existing jobs?

Question3: A CRM Analytics administrator is working on deploying a dataflow and a dataset (generated by this dataflow) to another org.
While creating a change set, they notice that the components are NOT visible to be included in the change set.
What is the reason for this?

Question4: A manager at Cloud Kicks wants to separate and analyze accounts based on numeric information of its opportunity records. The data includes things like amount, quantity of products, contacts, and quotes.
How should the CRM Analytics consultant accomplish this?

Question5: What is the purpose of the CRM Analytics Dashboard Inspector?

Question6: Universal Containers is setting up a Sales Analytics app to track the sales performance across all regions. The role hierarchy is well-structured with separate branches for various global regions.
Viewer access has been provided to the regional sales reps based on the following roles.
* Regional Sales - APAC
* Regional Sales - EMEA
* Regional Sales - LATAM
* Regional Sales - NA
The CRM Analytics project team receives a request to extend Editor
access to the app to 20 'Superusers' across all regions.
What is the optimal solution?

Question7: Cloud Kicks (CK) wants to use CRM Analytics to analyze trends of its sales pipeline in order to accelerate the company's sales process. To do so, CK needs to know the average time an opportunity spends in each stage. The data can be found in the Opportunity History object, but the value is not pre-calculated in Salesforce, so a consultant recommends using a recipe to calculate it.
How should the consultant use a recipe to calculate the average time an opportunity spends in each stage?

Question8: Several users are complaining they are unable to see a specific dashboard on a Salesforce Lightning page anymore. The CRM Analytics consultant logs in as one of the users and sees an error page once the dashboard is opened.
How should the consultant solve this issue?

Question9: Universal Containers has a single dataset that contains the attainment and commission fields for all sales reps. Each sales rep should be able view the attainment data for each rep in their division. Each rep should only be able to see their own commission dat a.
Which option should a CRM Analytics consultant use to enforce this requirement?

Question10: The CRM Analytics consultant at Universal Containers notices that some users have access to sensitive data and dashboards they should not have access to in the Manager's app.
How should the consultant fix the problem?

Question11: Universal Containers (UC) is looking to create a dashboard for whitespace analysis. UC wants to view a particular customer and see what similar customers have bought.
Which recipe transformation is helpful for the consultant to use while creating the dataset?

Question12: A CRM Analytics consultant is asked to make sure the new sales performance dashboard is accessible in the mobile app. They have created multiple mobile layouts for the same dashboard.
How is CRM Analytics expected to perform?

Question13: In Data Alerts, a field named Region is 96.5% North Americ
a. The consultant believes that this is an important field since the majority of sales is in the North American market.
What is the appropriate action?

Question14: A CRM Analytics consultant has enabled data sync manually in an org that uses dataflows/recipes. The client says that the dataflow/recipe fails each time it starts running.
What is causing the dataflow/recipe to fail?

Question15: A user is able to access the dashboards, lenses, and datasets of a particular app but is unable to change the name of the specific app.
What is causing the issue?

Question16: consultant is tasked with creating an opportunity dataset for a new analytics app. One requirement is to make sure users only see the opportunities they have access to in Salesforce. Opportunity records are private but shared using the role hierarchy. The consultant runs the sharing inheritance coverage assessment and finds that the VP of sales is not covered by the sharing inheritance. The consultant decides to proceed with using sharing inheritance for the dataset.
What else does the consultant need to do?

Question17: The CRM Analytics consultant at Cloud Kicks is asked to make sure the data on the CRM Analytics dashboard be as real-time as possible.
It was agreed to set the sync refresh time to 5 minutes for one of the local connections. The org has a CRM Analytics Plus license but users are noticing that the earliest available time is 1 hour. The minutes option is not visible to the user.
What is causing the issue?

Question18: Which recommended technique should a CRM Analytics consultant
use to access CRM Analytics data from a remote app or website?

Question19: Universal Containers has a dashboard for sales managers. They need to visualize the percentage of their opportunities in the pipeline in a Gauge chart. They want to customize the chart to keep track if they are below or beyond the target.

Which widget parameters should a consultant use?

Question20: A CRM Analytics consultant is working on Sales dashboards with multiple datasets and advanced queries in the Sales Analytics app.
Sales managers in the organization have been given Editor/Manager access to the app, whereas sales reps have been given Viewer access.
Some dashboards that are in progress are not ready to be rolled out to sales reps and should only be viewable by sales managers.
How should the consultant accomplish this?

Question21: A CRM Analytics consultant is performing column profiling on dimension column in a recipe. Newly-added rows are not being considered in the Results tab of the profile even though a sync was run for that specific object.
What is causing the issue?

Question22: A CRM Analytics consultant has been asked to bring data from an external database as well as five external Salesforce environments into CRM Analytics. Twenty-five objects have been enabled from the local Salesforce connector.
The requirements are:
* 10 objects should be enabled from an external database
* 12 objects each from three of the external Salesforce environments
* 15 objects each from the remaining two external Salesforce environments The consultant estimates each connector will, per object, bring between 1,000 and 1 million rows of data.
Which limit will be exceeded?

Question23: A CRM Analytics consultant has enabled data sync manually in an org that uses dataflows/recipes. The client says that the dataflow/recipe fails each time it starts running.
What is causing the dataflow/recipe to fail?

Question24: Universal Containers has a well-defined role hierarchy in Salesforce where everyone is assigned to an appropriate node. The accounts within their instance are categorized by their demography.
An individual sales rep should be able to view all accounts that they own. In addition, sales reps should be able to see any accounts where the value of the account demography matches the demography defined on their user record. A user could have more than one demography defined on their user record.
To meet this requirement, the CRM Analytics consultant has set up a security predicate of the existing 'Account' dataset as follows:

This, however, does not seem to be working as expected.
What is causing the issue?

Question25: Universal Containers plans to upload target data from an external tool to CRM Analytics so it can calculate the sales team target attainments.
The target data changes every month, so the datasets need to be updated on a monthly basis. The target data is a CSV file that contains the Salesforce ID of the sales rep, the target amount, and the month of the target. For each sales rep, the file contains a target for every month of the current year as well as all previous years.
Based on this information, which operation should a consultant use with the Analytics External Data API to upload the file?

Question26: Exhibit.

Universal Containers has a dashboard for sales managers to visualize the Year Over Year (YoY) growth of their customers. The formula used is:
YoY = [(This Year - Last Year) / Last Year] %
Based on the graphic, when there is not an account in the Last Year column, the YoY Growth shows null results. The sales managers want to replace it with 100% value.
What is the correct function to use?

Question27: Which capability can a consultant use if "Deploy without connecting to a Salesforce Object" is selected while deploying the model?

Question28: What are various ways to incorporate blank space in a CRM Analytics dashboard?

Question29: AW Computing will start using Tableau Online to report on some of its Salesforce data to users who do NOT have an SFDC license.
What is the first step the CRM Analytics consultant should take?

Question30: What is a benefit of introducing a second local connector?

Question31: A consultant runs the sharing inheritance coverage assessment for the Opportunity object and finds that some records exceed 400 sharing descriptors.
What should the consultant do?

Question32: In a dataset, there are multiple boolean fields. When displayed on any dashboard, the boolean fields should all be displayed in the same way: a value of true should result in the display of the word "Yes" in green; a value of false should result in the display of the word "No" in red.
How should the consultant accomplish this?

Question33: Universal Containers (UC) builds three Einstein Discovery models in Salesforce to predict and maximize its revenue per customer. The models are for every region UC has a business: EMEA, AMER, and APAC.
How should a consultant help UC deploy the three Einstein models to Salesforce?

Question34: Universal Containers' CRM Analytics team is building a dashboard with two widgets, and the queries use different datasets.
1. List widget associated to the query "Type_2" and grouped by the dimension "Type" (multi-selection)
2. Donut chart widget associated to the query "Query_pie_3" and grouped by the dimension "Type" The team wants any selection in the List widget to filter the Donut chart and vice vers a. Users should be able to choose more than one Type (multi-selection).
What is the recommended way to accomplish the required filtering?

Question35: CRM Analytics consultant receives a new project from a client that wants to implement CRM Analytics. They do not currently have CRM Analytics but want guidance on how to ensure their users have the correct access.
They have 1,000 users with a small team of three people who will build both datasets and dashboards. An additional 15 people should be able to only create dashboards. The remaining users should only be able to view dashboards.
Which recommendation should the consultant give the client?
Which recommendation should the consultant give the client?

Question36: CRM Analytics users at Cloud Kicks are granted access to an app with specific dashboards. When trying to download a specific widget, they are unable to do so.
What is causing the issue?

Question37: Universal Containers builds a new sales dashboard and wants to make sure account managers can access the dashboard while traveling.
What should the consultant consider doing in this process?

Question38: Universal Containers (UC) has a "Sales Manager" dashboard. UC has a compare table that has multiple groupings and columns added showing the Total and Subtotals of the numeric values. A consultant is asked to add additional groups to enhance details about UC's customers.
Which feature should the consultant use to make the navigation of the compare tables easier for the end user?

Question39: A system administrator at Cloud Kicks creates a joined report to showcase the new business deals closing in the current quarter, which was well received by the business stakeholders. A manager wants to visualize this report on CRM Analytics.
The CRM Analytics consultant determines the report can be trended on CRM Analytics, but it's not working as expected.
What is causing the issue?

Question40: A consultant has been asked to build and embed a dashboard in a Lightning page. Users should only be able to change the dashboard contrast and open Analytics Studio from the header of the dashboard.
How should the consultant achieve this?

Question41: Universal Containers intends to use a custom Salesforce big object in its org and visualize the data using CRM Analytics. As the number of rows to be synced is quite large, the CRM Analytics consultant is looking to set up an incremental sync with additional filters added as part of the data sync to improve performance.
What should the consultant keep in mind while implementing this?

Question42: The CRM Analytics project team at Universal Containers is creating an app with dashboards, datasets, and lenses. The app has been shared with multiple users with Viewer, Editor, and/or Manager access.
One end user is unable to view the dashboard watchlist that was previously set up. They are receiving a "Resource not found" error while trying to access the dashboard. The team confirms that the end user has Viewer access to the app but the project team is able to view the dashboard.
What is the reason for this error?

Question43: A system administrator and a CRM Analytics consultant are working together on deploying arecipe/dataflow and a dataset to another org. Prior to this deployment, a package was deployed with all the custom fields used in the dataflow and dataset.
While running the recipe/dataflow in the target environment, the consultant encounters multiple errors related to these custom fields.
How should this be resolved?

Question44: The sole manager of a CRM Analytics app at Cloud Kicks is leaving the company.
What should the CRM Analytics consultant do to ensure the app remains accessible?

Question45: A CRM Analytics consultant at Cloud Kicks is trying to upload data using an External Data API and the CSV file with the data was uploaded successfully. Upon analyzing the data using a lens, they find they are unable to perform any mathematical operations as all the data and fields are treated as dimensions.
What is causing the problem?

Question46: Universal Containers (UC) uses a Microsoft Azure SQL Data Warehouse to gather information about sales reps' objectives. UC wants to use CRM Analytics to gain insights from this data and automatically load it into a CRM Analytics dataset daily. The data also needs to be transformed and merged with data from the company's org.
Which CRM Analytics user interface features should be used to complete these requirements?

Question47: Universal Containers (UC) is using CRM Analytics to create two datasets.
* Dataset A: Contains a list of activities with an "activityID" dimension and a "userID" dimension
* Dataset B: Contains a list of users with a "userID" dimension
UC wants to delete all activities from Dataset A related to users in Dataset B.
How should the CRM Analytics consultant help UC achieve this?

Question48: After the initial creation of a model, the first model insight explains
93% of the variation of the outcome variable. This is unusually high.
What is the most likely reason for this?

Question49: The marketing team at Cloud Kicks has five dashboards in an app. Four widgets are replicas of each other in three of the dashboards.
What is the best way to maintain these widgets?

Question50: The administrator at Cloud Kicks has been asked to sync data from an external object created in Salesforce into CRM Analytics.
What should the administrator keep in mind?

Question51: A new picklist value was added for the Category field on the Account object. This field is already added as part of the Account object data sync and the respective recipe that uses this field.
The CRM Analytics team reports that when they start the recipe it runs successfully with no errors or warnings, but they are unable to See this new values on their existing dashboards.
What is the oridi4 of this issue?